UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZyL5dexLVTLo+nAj+beG5DPHXA+zw12cHUYwn3klETY='
WHERE
key_id = 'f1cb493c2d1763091e2539c81685b4fd786f792cd2ab8f70d571aa67c8ce6dfb'
AND (
token = 'ZyL5dexLVTLo+nAj+beG5DPHXA+zw12cHUYwn3klETY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)