UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TQRPYl5kMHWUrVXae4y0FuW7yuDYwY8+tLSA/SSTibA='
WHERE
key_id = 'f31d95d39583c715e39c8fad8c446764d4803215af5a106c0f6ce614796e734d'
AND (
token = 'TQRPYl5kMHWUrVXae4y0FuW7yuDYwY8+tLSA/SSTibA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)