UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '14wnWU5KPMwiRUIJB5j3odVX2Oiss3hAoOh/53xF66E='
WHERE
key_id = '2aa9cf4eee6e30b74564d952a0a5b00ce9a2f1a43b944fb342eef93543e28f38'
AND (
token = '14wnWU5KPMwiRUIJB5j3odVX2Oiss3hAoOh/53xF66E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)