UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nuAVuyK4bKWcn2BLumTTeyg7flLRW4Q8NK+zfCZKtCs='
WHERE
key_id = 'd3dcfb8276946cc2c88bc9e15ff6c6ba07248f272e336e8f7ad5f1503f07e027'
AND (
token = 'nuAVuyK4bKWcn2BLumTTeyg7flLRW4Q8NK+zfCZKtCs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)