UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MiMVk5ct7+4HjDHAr/m7a3NA8L+Ls20O9p2s/fByZgc='
WHERE
key_id = '6ec17f71b57796a01701662b2b8dbdc0fd6b51620ee806d244abb1c5af3a5d8a'
AND (
token = 'MiMVk5ct7+4HjDHAr/m7a3NA8L+Ls20O9p2s/fByZgc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)