UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/f3e9OUcwP9ZHQdlkG48Ky58y7rcm4b0gLY8FtrMmgk='
WHERE
key_id = '5cb7c8fd767f4799883a30773f27b147fd7102071f46a2df5f832ae4c5acdff9'
AND (
token = '/f3e9OUcwP9ZHQdlkG48Ky58y7rcm4b0gLY8FtrMmgk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)