UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jcYBFDKmnuOKq3o5x3JB9v4G9V/mWpRfRD55QeY73z8='
WHERE
key_id = '336137e9e7779d07d0b6ea045707da8d9fe7d81e5b02dce5bc686e8ee1879cd4'
AND (
token = 'jcYBFDKmnuOKq3o5x3JB9v4G9V/mWpRfRD55QeY73z8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)