UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W9lk7JgY0G9SDuxG+VwX7WBfC9BJsYucqSjfTWwAicU='
WHERE
key_id = '84f1b02b0a80e7e408ecd7a2a1cfbd8f87b3845e351f55a0f7ae0bdab26c2d7a'
AND (
token = 'W9lk7JgY0G9SDuxG+VwX7WBfC9BJsYucqSjfTWwAicU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)