UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1+2/tzyv0ITC9DvAM/tsoMxmSEHP44m4VYTDg1CzKwo='
WHERE
key_id = '18b776cf1faeb217008aa27390fab42661979b8c805f0033a12324c80d56e6ea'
AND (
token = '1+2/tzyv0ITC9DvAM/tsoMxmSEHP44m4VYTDg1CzKwo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)