UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nv/1UHmyB5vf8jnE6VH/SIk90NMPeG0AvzmJu56ogyE='
WHERE
key_id = 'b29f9fdc0bdda00ce4d38d8d0f534a0fe6775df3786f178fda663dad36aad800'
AND (
token = 'nv/1UHmyB5vf8jnE6VH/SIk90NMPeG0AvzmJu56ogyE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)