UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TbAWkgGRmC4qAX+JniKbCc/4r/1g8KZqUeHg8uU5OgE='
WHERE
key_id = '0af9286dbe0c02164cc712761b49d8c28c5acd881387efb41ee82fd9fee61c8a'
AND (
token = 'TbAWkgGRmC4qAX+JniKbCc/4r/1g8KZqUeHg8uU5OgE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)