UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TvTHXE7I13cE7a0zZzL4o58rF7pycReV3YFhoCSq5Ps='
WHERE
key_id = '9a5ca35c38902e159fd357641a8e5488cebc8ee78d8dc822f5bd72c9309174ee'
AND (
token = 'TvTHXE7I13cE7a0zZzL4o58rF7pycReV3YFhoCSq5Ps='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)