UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zru7NLUFrClS3cXynLyTuRzRgrWCBPL0BgYj8S4dggs='
WHERE
key_id = 'c20c0f643e4f60e49fb4446c6a2cd24fa744c06741c5b5167c4c634930cbe175'
AND (
token = 'Zru7NLUFrClS3cXynLyTuRzRgrWCBPL0BgYj8S4dggs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)