UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c8t5UpceRKfGujnt8DwfyEgnsGElK2nZnZnYTDeSpjg='
WHERE
key_id = '67c5f36f84c8f38c97ca3530919292417f99c22b133e1a6e81227d28da42999c'
AND (
token = 'c8t5UpceRKfGujnt8DwfyEgnsGElK2nZnZnYTDeSpjg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)