UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BH6rPbWwF6QlZ0vOlOvVFvlYy37+urHjk/DzeEqRrG8='
WHERE
key_id = '2970ab816b435ae8916fd2e0f9c07bda01885e8a4b0b2cd4c1131866e72177ec'
AND (
token = 'BH6rPbWwF6QlZ0vOlOvVFvlYy37+urHjk/DzeEqRrG8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)