UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0LpP/s1BpPZi3mkz3s2NUJxPPUkCs/yJ5KYjWsIKzrM='
WHERE
key_id = 'd8e19c9a0de7e13dabd343ba63d1be5534f2c9c261a77105478335a96165df7d'
AND (
token = '0LpP/s1BpPZi3mkz3s2NUJxPPUkCs/yJ5KYjWsIKzrM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)