UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6vpPqzOfA6aTnSvM+FKyiu9WUHN3uEdoDZHbc3NsBIw='
WHERE
key_id = '0eec4795728e6f21f78bf95838abdcef71058cc9b09b5cc7c54a28b6b6963ea3'
AND (
token = '6vpPqzOfA6aTnSvM+FKyiu9WUHN3uEdoDZHbc3NsBIw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)