UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9PtkMkEV/qjaLeB3L+IQ5PbN/inUJy6lV/2HfJj6zvA='
WHERE
key_id = '297437e7c123a5e21142cf532d71ff96b992a678a03fdea4702ba99833d00146'
AND (
token = '9PtkMkEV/qjaLeB3L+IQ5PbN/inUJy6lV/2HfJj6zvA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)