UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yyfXo6ff9TIyr2YTSQVKZ0yzrjarXEWX0jsOZHxaW+4='
WHERE
key_id = '29651330bce6e3b1f1245adb0a5c473069d0987622e4881012f825788d02287a'
AND (
token = 'yyfXo6ff9TIyr2YTSQVKZ0yzrjarXEWX0jsOZHxaW+4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)