UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xLa5WKYr9/tVafacRtQOo5nhyRgfNxFn50vI3TC9Snk='
WHERE
key_id = '420985e3b16d6ec4b9220c25e595c27b5c3fff449efa5360167f79fdd3330882'
AND (
token = 'xLa5WKYr9/tVafacRtQOo5nhyRgfNxFn50vI3TC9Snk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)