UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YmVEr+uoBYkRf7hqXFx765MzMe28N5VwBncdXCts/gM='
WHERE
key_id = 'd2f39c87eb979b087ecc50ae68a3d28ef0e8083a38c12e5a7a063e28613564e2'
AND (
token = 'YmVEr+uoBYkRf7hqXFx765MzMe28N5VwBncdXCts/gM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)