UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qig1a7rwqo1lpA7z3rGyTB0KJYiWAODGeOP00mEC9Wk='
WHERE
key_id = 'b18718b9e5f7563ff102e165b38af4f06c327a47819c9ed10868fc03239c8686'
AND (
token = 'qig1a7rwqo1lpA7z3rGyTB0KJYiWAODGeOP00mEC9Wk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)