UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P/HdFK71P4TGxCJODLhutfHaDqcmTk4p7aEk1CeOii4='
WHERE
key_id = '556272828d3efc8b44d833d193083671771c5a6b6ea3e39b9340c626d84f6769'
AND (
token = 'P/HdFK71P4TGxCJODLhutfHaDqcmTk4p7aEk1CeOii4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)