UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/zDzdW2LczSltbLLNq4Ef1Ch85xeG12C5ZND8E+nGuA='
WHERE
key_id = '84ce997340a8f683e2ac3585b3349a16197021b52915f00114078ad0e3401af7'
AND (
token = '/zDzdW2LczSltbLLNq4Ef1Ch85xeG12C5ZND8E+nGuA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)