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