UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'miJySBuxEZm8V+nnHDDrSq6pT59CNoIQ3fi0Y4whYEw='
WHERE
key_id = 'a828e5a78dad9051672bb6ca448ca080aea305ba9f1363baba3c716f494489bc'
AND (
token = 'miJySBuxEZm8V+nnHDDrSq6pT59CNoIQ3fi0Y4whYEw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)