UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6U+hxRBfhKX+3gG1MPqwkS2xaCIDRJJb0nt02kfW9cc='
WHERE
key_id = '6dc4d7f166aee16d667a14c60b2b93b28764785291e591b01bdba9eeb54e5f9a'
AND (
token = '6U+hxRBfhKX+3gG1MPqwkS2xaCIDRJJb0nt02kfW9cc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)