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